package cn.iune.backcenter.authen;

import javax.persistence.*;

import com.justep.baas.data.RowState;

import java.io.Serializable;
import java.sql.Date;
import java.sql.Timestamp;


/**
 * The persistent class for the sa_opperson database table.
 * 
 */

@Entity
@Table(name="SaOpperson"	
, uniqueConstraints = { 
		@UniqueConstraint(columnNames = { "sLoginName"/*, "slevel"*/ })
		,@UniqueConstraint(columnNames = { "sMail"/*, "slevel"*/ })
		,@UniqueConstraint(columnNames = { "sMobilePhone"/*, "slevel"*/ })
	}
)
@NamedQuery(name="SaOpperson.findAll", query="SELECT s FROM SaOpperson s")
public class SaOpperson implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(length=32)
	private String sID;
	@Column(length=20)
	private String sName;//名称
	@Column(length=15)
	private String sCode;//代码
	
	@Column(length=36)
	private String sIDCard;//身份证号
	private int sNumb;//数字编号
	@Column(length=64)
	private String sLoginName;//登录名
	@Column(length=64)
	private String sPassword;//密码(MD5)
	private int sPasswordTimeLimit;//密码时限（天）
	private Date sPasswordModifyTime;//密码修改时间
	@Column(length=36)
	private String sMainOrgID;//所属公司（注册时=sID）
	@Column(length=36)
	private String sSafeLevelID;//密级

	private int sSequence;//序号

	private int sValidState = 1;//可用状态
	@Column(length=2048)
	private String sDescription;//描述

//	@Lob
//	private byte[] sPhoto;//照片
	@Column(length=8)
	private String sSex;//性别

	private Date sBirthday;//出生日期

	private Date sJoinDate;//参加工作日期
	@Column(length=64)
	private String sHomePlace;//出生地
	@Column(length=64)
	private String sCountry;//国家
	@Column(length=64)
	private String sProvince;//省
	@Column(length=64)
	private String sCity;//市
	@Column(length=16)
	private String sDegree;//学历
	@Column(length=128)
	private String sGraduateSchool;//毕业院校
	@Column(length=128)
	private String sSpeciality;//专业
	@Column(length=16)
	private String sSchoolLength;//学年制
	@Column(length=64)
	private String sTitle;//职称
	@Column(length=16)
	private String sMarriage;//婚姻状况
	@Column(length=36)
	private String sCardNO;//证件号码
	@Column(length=64)
	private String sCardKind;//证件类型
	@Column(length=255)
	private String sFamilyAddress;//家庭住址
	@Column(length=16)
	private String sZip;//邮编
	@Column(length=64)
	private String sMsn;//MSN
	@Column(length=36)
	private String sQQ;//QQ
	@Column(length=64)
	private String sMail;//电子邮件
	private int sMailState = 1;//可用状态
	@Column(length=36)
	private String sMobilePhone;//移动电话
	private int sMobileState = 1;//可用状态
	@Column(length=36)
	private String sFamilyPhone;//家庭电话
	@Column(length=36)
	private String sOfficePhone;//办公电话
	@Column(length=128)
	private String sEnglishName;//英文名称
	@Column(length=256)
	private String sCreatorFID;//创始人
	private Timestamp createDate;
	
	@Column(length=256)
	private String images;//店铺头像
	
	
	/*
	private String accountBank;
	private String accountNo;
	private BigDecimal basePay;
	private String contractNo;
	private Date expireDate;
	private int fullwork;
	private BigDecimal fullworkPay;
	private int overtime;
	private BigDecimal overtimeRate;
	private int payType;
	private String payTypeLabel;
	private int payWhere;
	private String payWhereLabel;
	private Date preRetireDate;
	private Date quitDate;
	private Date retireDate;
	private Date signingDate;
	private String spositions;
	private String sschool;
	private String sstudy;
	private int taxType;
	private String taxTypeLabel;
	private Date workDate;
	private BigDecimal yearRate;
	*/
	
	private Timestamp registerDate;
	@Column(length=36)
	private String validataCode;

	
	@Version
	private int version = 0;
	
	@Transient//非持久字段
	private RowState rowState;
	public RowState getRowState() {
		return rowState;
	}
	public void setRowState(RowState rowState) {
		this.rowState = rowState;
	}

	public String getsID() {
		return sID;
	}

	public void setsID(String sID) {
		this.sID = sID;
	}

	public Date getsBirthday() {
		return sBirthday;
	}

	public void setsBirthday(Date sBirthday) {
		this.sBirthday = sBirthday;
	}

	public String getsCardKind() {
		return sCardKind;
	}

	public void setsCardKind(String sCardKind) {
		this.sCardKind = sCardKind;
	}

	public String getsCardNO() {
		return sCardNO;
	}

	public void setsCardNO(String sCardNO) {
		this.sCardNO = sCardNO;
	}

	public String getsCity() {
		return sCity;
	}

	public void setsCity(String sCity) {
		this.sCity = sCity;
	}

	public String getsCode() {
		return sCode;
	}

	public void setsCode(String sCode) {
		this.sCode = sCode;
	}

	public String getsCountry() {
		return sCountry;
	}

	public void setsCountry(String sCountry) {
		this.sCountry = sCountry;
	}

	public String getsDegree() {
		return sDegree;
	}

	public void setsDegree(String sDegree) {
		this.sDegree = sDegree;
	}

	public String getsDescription() {
		return sDescription;
	}

	public void setsDescription(String sDescription) {
		this.sDescription = sDescription;
	}

	public String getsEnglishName() {
		return sEnglishName;
	}

	public void setsEnglishName(String sEnglishName) {
		this.sEnglishName = sEnglishName;
	}

	public String getsFamilyAddress() {
		return sFamilyAddress;
	}

	public void setsFamilyAddress(String sFamilyAddress) {
		this.sFamilyAddress = sFamilyAddress;
	}

	public String getsFamilyPhone() {
		return sFamilyPhone;
	}

	public void setsFamilyPhone(String sFamilyPhone) {
		this.sFamilyPhone = sFamilyPhone;
	}

	public String getsGraduateSchool() {
		return sGraduateSchool;
	}

	public void setsGraduateSchool(String sGraduateSchool) {
		this.sGraduateSchool = sGraduateSchool;
	}

	public String getsHomePlace() {
		return sHomePlace;
	}

	public void setsHomePlace(String sHomePlace) {
		this.sHomePlace = sHomePlace;
	}

	public String getsIDCard() {
		return sIDCard;
	}

	public void setsIDCard(String sIDCard) {
		this.sIDCard = sIDCard;
	}

	public Date getsJoinDate() {
		return sJoinDate;
	}

	public void setsJoinDate(Date sJoinDate) {
		this.sJoinDate = sJoinDate;
	}

	public String getsLoginName() {
		return sLoginName;
	}

	public void setsLoginName(String sLoginName) {
		this.sLoginName = sLoginName;
	}

	public String getsMail() {
		return sMail;
	}

	public void setsMail(String sMail) {
		this.sMail = sMail;
	}

	public String getsMainOrgID() {
		return sMainOrgID;
	}

	public void setsMainOrgID(String sMainOrgID) {
		this.sMainOrgID = sMainOrgID;
	}

	public String getsMarriage() {
		return sMarriage;
	}

	public void setsMarriage(String sMarriage) {
		this.sMarriage = sMarriage;
	}

	public String getsMobilePhone() {
		return sMobilePhone;
	}

	public void setsMobilePhone(String sMobilePhone) {
		this.sMobilePhone = sMobilePhone;
	}

	public String getsMsn() {
		return sMsn;
	}

	public void setsMsn(String sMsn) {
		this.sMsn = sMsn;
	}

	public String getsName() {
		return sName;
	}

	public void setsName(String sName) {
		this.sName = sName;
	}

	public int getsNumb() {
		return sNumb;
	}

	public void setsNumb(int sNumb) {
		this.sNumb = sNumb;
	}

	public String getsOfficePhone() {
		return sOfficePhone;
	}

	public void setsOfficePhone(String sOfficePhone) {
		this.sOfficePhone = sOfficePhone;
	}

	public String getsPassword() {
		return sPassword;
	}

	public void setsPassword(String sPassword) {
		this.sPassword = sPassword;
	}

	public Date getsPasswordModifyTime() {
		return sPasswordModifyTime;
	}

	public void setsPasswordModifyTime(Date sPasswordModifyTime) {
		this.sPasswordModifyTime = sPasswordModifyTime;
	}

	public int getsPasswordTimeLimit() {
		return sPasswordTimeLimit;
	}

	public void setsPasswordTimeLimit(int sPasswordTimeLimit) {
		this.sPasswordTimeLimit = sPasswordTimeLimit;
	}

	public String getsProvince() {
		return sProvince;
	}

	public void setsProvince(String sProvince) {
		this.sProvince = sProvince;
	}

	public String getsQQ() {
		return sQQ;
	}

	public void setsQQ(String sQQ) {
		this.sQQ = sQQ;
	}

	public String getsSafeLevelID() {
		return sSafeLevelID;
	}

	public void setsSafeLevelID(String sSafeLevelID) {
		this.sSafeLevelID = sSafeLevelID;
	}

	public String getsSchoolLength() {
		return sSchoolLength;
	}

	public void setsSchoolLength(String sSchoolLength) {
		this.sSchoolLength = sSchoolLength;
	}

	public int getsSequence() {
		return sSequence;
	}

	public void setsSequence(int sSequence) {
		this.sSequence = sSequence;
	}

	public String getsSex() {
		return sSex;
	}

	public void setsSex(String sSex) {
		this.sSex = sSex;
	}

	public String getsSpeciality() {
		return sSpeciality;
	}

	public void setsSpeciality(String sSpeciality) {
		this.sSpeciality = sSpeciality;
	}

	public String getsTitle() {
		return sTitle;
	}

	public void setsTitle(String sTitle) {
		this.sTitle = sTitle;
	}

	public int getsValidState() {
		return sValidState;
	}

	public void setsValidState(int sValidState) {
		this.sValidState = sValidState;
	}

	public String getsZip() {
		return sZip;
	}

	public void setsZip(String sZip) {
		this.sZip = sZip;
	}

	public int getVersion() {
		return version;
	}

	public void setVersion(int version) {
		this.version = version;
	}
	public String getsCreatorFID() {
		return sCreatorFID;
	}
	public void setsCreatorFID(String sCreatorFID) {
		this.sCreatorFID = sCreatorFID;
	}

	public String getValidataCode() {
		return validataCode;
	}
	public void setValidataCode(String validataCode) {
		this.validataCode = validataCode;
	}
	public Timestamp getRegisterDate() {
		return registerDate;
	}
	public void setRegisterDate(Timestamp registerDate) {
		this.registerDate = registerDate;
	}
	public int getsMailState() {
		return sMailState;
	}
	public void setsMailState(int sMailState) {
		this.sMailState = sMailState;
	}
	public int getsMobileState() {
		return sMobileState;
	}
	public void setsMobileState(int sMobileState) {
		this.sMobileState = sMobileState;
	}
	public Timestamp getCreateDate() {
		return createDate;
	}
	public void setCreateDate(Timestamp createDate) {
		this.createDate = createDate;
	}
	public String getImages() {
		return images;
	}
	public void setImages(String images) {
		this.images = images;
	}


}